create table IdentityDemo ( SrNumber int PRIMARY KEY Identity(1,1), Name varchar(10) NOT NULL, Age int NULL, City varchar(5) ); insert into IdentityDemo (Name) values ('ABC'); insert into IdentityDemo (Name,Age,City) values ('BCD',10,'HYD'); select * from IdentityDemo